USE [influenza]
GO

/****** Object:  StoredProcedure [dbo].[SP_datAuxResultLab]    Script Date: 02/09/2010 03:50:07 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE PROCEDURE [dbo].[SP_datAuxResultLab]
@param varchar(50)
as
Begin
declare @qry VARCHAR(8000)

SET @qry='select b.resultados
from aux_laboratorio_res a
inner join cat_lab_resultados b on(a.nResultado=b.id_resultados)
Where id_dat_registro='+@param

exec (@qry)

End
GO

